﻿CREATE TABLE [dbo].[RawEvents] (
    [ID]             INT           IDENTITY (1, 1) NOT NULL,
    [MeterNumber]    NVARCHAR (50) NOT NULL,
    [MeterVendorID]  NVARCHAR (50) NOT NULL,
    [MeterHeadEndID] NVARCHAR (50) NOT NULL,
    [TimeStamp]      DATETIME      NOT NULL,
    [EventType]      NVARCHAR (50) NOT NULL,
    [Reading]        FLOAT         NOT NULL,
    [Temp]           FLOAT         NOT NULL
);



